--SELECT * FROM ResumeSkill
--DELETE FROM ResumeSkill
--INSERT INTO srv_lnk.nchr2008.dbo.ResumeSkill
SELECT top 5
Convert(int,right(id,7)) AS [ID],Convert(int,right(resumeid,7))  AS [ResumeID],[Subject] AS [SkillSubject],[Body] AS [SkillContent],'Chinese' AS [strLanguage],0 AS [Flag],Convert(int,right(resumeid,7)) AS [CreatedUserId],[DateCreated] AS [CreatedDate],Convert(int,right(resumeid,7)) AS [UpdatedUserId],[LastUpdated]AS [UpdatedDate]FROM Forest.dbo.cv_skill
SELECT TOP 5 * FROM Forest.dbo.cv_skill
select top 5 * from srv_lnk.nchr2008.dbo.ResumeSkill
